Thin yield spreads and oversupply are cooling once-hot Sunbelt metros, while affordable housing and Midwest balance are keeping investors in the game.